package com.zengqingfa.imp.demo.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @fileName: Emp
 * @author: zengqf3
 * @date: 2021-3-3 11:25
 * @description:
 */
@Data
public class EmpExportDTO implements Serializable {

    @ExcelProperty(value = "主键",index = 1)
    private Integer id;
    @ExcelProperty(value = "员工编号",index = 2)
    private Integer empno;
    @ExcelProperty(value = "员工姓名",index = 3)
    private String ename;
    @ExcelProperty(value = "员工工作",index = 4)
    private String job;
    @ExcelProperty(value = "上级编号",index = 5)
    private Integer mgr;
    @ExcelProperty(value = "雇佣日期",index = 6)
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    private Date hiredate;
    @ExcelProperty(value = "薪金",index = 7)
    private Double sal;
    @ExcelProperty(value = "佣金",index = 8)
    private Double comm;
    @ExcelProperty(value = "部门编号",index = 9)
    private Integer deptno;
    @ExcelProperty(value = "性别：1男2女",index = 10)
    private Integer sex;

}
